Owner

dbo

Creation Date

10-07-2003 10:31:36

Remarks

Columns

Name	Type	Length	IsNullable	Collation
ShippedDate	datetime	8
OrderID	int	4
Subtotal	money	8

View Definition

create view "Summary of Sales by Year" AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate IS NOT NULL
--ORDER BY Orders.ShippedDate